Electricity consumption Data Pre-Profiling Report

Dataset statistics

Number of variables	13
Number of observations	52416
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	4.6 MiB
Average record size in memory	92.0 B

Variable types

Numeric	12
Categorical	1

Alerts

`Year` has constant value "2017"	Constant
`DiffuseFlows` is highly overall correlated with `GeneralDiffuseFlows`	High correlation
`GeneralDiffuseFlows` is highly overall correlated with `DiffuseFlows`	High correlation
`Hour` is highly overall correlated with `PowerConsumption_Zone1` and 1 other fields	High correlation
`PowerConsumption_Zone1` is highly overall correlated with `Hour` and 2 other fields	High correlation
`PowerConsumption_Zone2` is highly overall correlated with `Hour` and 2 other fields	High correlation
`PowerConsumption_Zone3` is highly overall correlated with `PowerConsumption_Zone1` and 1 other fields	High correlation
`Hour` has 2184 (4.2%) zeros	Zeros
`Minute` has 8736 (16.7%) zeros	Zeros

Reproduction

Analysis started	2025-01-19 05:09:03.715467
Analysis finished	2025-01-19 05:09:43.779854
Duration	40.06 seconds
Software version	ydata-profiling vv4.12.1
Download configuration	config.json

Temperature
Real number (ℝ)

Distinct	3437
Distinct (%)	6.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	18.810024

Minimum	3.247
Maximum	40.01
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	3.247
5-th percentile	9.8
Q1	14.41
median	18.78
Q3	22.89
95-th percentile	28.39
Maximum	40.01
Range	36.763
Interquartile range (IQR)	8.48

Descriptive statistics

Standard deviation	5.8154758
Coefficient of variation (CV)	0.30916898
Kurtosis	-0.30332122
Mean	18.810024
Median Absolute Deviation (MAD)	4.26
Skewness	0.19671914
Sum	985946.22
Variance	33.819759
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
15.18	58	0.1%
20.76	56	0.1%
19.79	55	0.1%
20.74	52	0.1%
20.83	51	0.1%
15.85	51	0.1%
15.84	51	0.1%
21	50	0.1%
20.89	50	0.1%
20.37	49	0.1%
Other values (3427)	51893	99.0%

Value	Count	Frequency (%)
3.247	1	< 0.1%
3.441	1	< 0.1%
3.541	1	< 0.1%
3.555	1	< 0.1%
3.582	1	< 0.1%
3.629	1	< 0.1%
3.638	1	< 0.1%
3.662	1	< 0.1%
3.681	1	< 0.1%
3.706	1	< 0.1%

Value	Count	Frequency (%)
40.01	1	< 0.1%
39.78	1	< 0.1%
39.76	1	< 0.1%
39.74	1	< 0.1%
39.73	1	< 0.1%
39.7	1	< 0.1%
39.67	1	< 0.1%
39.6	1	< 0.1%
39.59	1	< 0.1%
39.55	1	< 0.1%

Humidity
Real number (ℝ)

Distinct	4443
Distinct (%)	8.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.259518

Minimum	11.34
Maximum	94.8
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	11.34
5-th percentile	39.45
Q1	58.31
median	69.86
Q3	81.4
95-th percentile	88.9
Maximum	94.8
Range	83.46
Interquartile range (IQR)	23.09

Descriptive statistics

Standard deviation	15.551177
Coefficient of variation (CV)	0.2278243
Kurtosis	-0.12185965
Mean	68.259518
Median Absolute Deviation (MAD)	11.54
Skewness	-0.62516601
Sum	3577890.9
Variance	241.83911
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
85.9	197	0.4%
84.6	190	0.4%
85	189	0.4%
86.6	187	0.4%
86.3	186	0.4%
85.8	185	0.4%
87.2	175	0.3%
86.8	173	0.3%
87.4	171	0.3%
86.9	171	0.3%
Other values (4433)	50592	96.5%

Value	Count	Frequency (%)
11.34	2	< 0.1%
11.57	1	< 0.1%
11.94	1	< 0.1%
12.27	1	< 0.1%
12.3	1	< 0.1%
12.6	1	< 0.1%
12.74	1	< 0.1%
12.87	1	< 0.1%
13.04	1	< 0.1%
13.07	1	< 0.1%

Value	Count	Frequency (%)
94.8	3	< 0.1%
94.7	4	< 0.1%
94.6	1	< 0.1%
94.5	2	< 0.1%
94.4	1	< 0.1%
94.3	2	< 0.1%
94.2	4	< 0.1%
94.1	6	< 0.1%
94	9	< 0.1%
93.9	10	< 0.1%

WindSpeed
Real number (ℝ)

Distinct	548
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.9594889

Minimum	0.05
Maximum	6.483
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	0.05
5-th percentile	0.069
Q1	0.078
median	0.086
Q3	4.915
95-th percentile	4.923
Maximum	6.483
Range	6.433
Interquartile range (IQR)	4.837

Descriptive statistics

Standard deviation	2.348862
Coefficient of variation (CV)	1.1987116
Kurtosis	-1.7831692
Mean	1.9594889
Median Absolute Deviation (MAD)	0.016
Skewness	0.46242332
Sum	102708.57
Variance	5.5171525
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.082	2291	4.4%
0.083	1979	3.8%
0.084	1831	3.5%
0.081	1804	3.4%
0.085	1513	2.9%
0.08	1502	2.9%
0.073	1485	2.8%
4.919	1430	2.7%
4.916	1375	2.6%
0.072	1369	2.6%
Other values (538)	35837	68.4%

Value	Count	Frequency (%)
0.05	1	< 0.1%
0.053	5	< 0.1%
0.054	10	< 0.1%
0.055	13	< 0.1%
0.056	9	< 0.1%
0.057	17	< 0.1%
0.058	4	< 0.1%
0.059	7	< 0.1%
0.06	9	< 0.1%
0.061	11	< 0.1%

Value	Count	Frequency (%)
6.483	1	< 0.1%
6.325	1	< 0.1%
6.2	1	< 0.1%
5.817	1	< 0.1%
5.69	1	< 0.1%
5.402	1	< 0.1%
5.375	1	< 0.1%
5.044	1	< 0.1%
5.019	1	< 0.1%
5.014	2	< 0.1%

GeneralDiffuseFlows
Real number (ℝ)

High correlation

Distinct	10504
Distinct (%)	20.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	182.69661

Minimum	0.004
Maximum	1163
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	0.004
5-th percentile	0.037
Q1	0.062
median	5.0355
Q3	319.6
95-th percentile	782
Maximum	1163
Range	1162.996
Interquartile range (IQR)	319.538

Descriptive statistics

Standard deviation	264.40096
Coefficient of variation (CV)	1.4472132
Kurtosis	0.40276752
Mean	182.69661
Median Absolute Deviation (MAD)	5.0095
Skewness	1.3069729
Sum	9576225.7
Variance	69907.867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.055	1576	3.0%
0.062	1557	3.0%
0.051	1497	2.9%
0.059	1474	2.8%
0.066	1459	2.8%
0.048	1388	2.6%
0.044	1292	2.5%
0.073	1262	2.4%
0.04	1125	2.1%
0.077	1116	2.1%
Other values (10494)	38670	73.8%

Value	Count	Frequency (%)
0.004	3	< 0.1%
0.007	9	< 0.1%
0.011	38	0.1%
0.015	97	0.2%
0.018	184	0.4%
0.022	309	0.6%
0.026	436	0.8%
0.029	566	1.1%
0.033	699	1.3%
0.037	924	1.8%

Value	Count	Frequency (%)
1163	1	< 0.1%
1122	1	< 0.1%
1102	1	< 0.1%
1099	1	< 0.1%
1082	1	< 0.1%
1069	1	< 0.1%
1055	1	< 0.1%
1051	1	< 0.1%
1050	1	< 0.1%
1044	1	< 0.1%

DiffuseFlows
Real number (ℝ)

High correlation

Distinct	10449
Distinct (%)	19.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	75.028022

Minimum	0.011
Maximum	936
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	0.011
5-th percentile	0.085
Q1	0.122
median	4.456
Q3	101
95-th percentile	331.85
Maximum	936
Range	935.989
Interquartile range (IQR)	100.878

Descriptive statistics

Standard deviation	124.21095
Coefficient of variation (CV)	1.6555274
Kurtosis	7.0029015
Mean	75.028022
Median Absolute Deviation (MAD)	4.393
Skewness	2.4569065
Sum	3932668.8
Variance	15428.36
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.115	1260	2.4%
0.122	1218	2.3%
0.119	1201	2.3%
0.126	1150	2.2%
0.111	1140	2.2%
0.13	1093	2.1%
0.104	1085	2.1%
0.1	963	1.8%
0.137	926	1.8%
0.096	915	1.7%
Other values (10439)	41465	79.1%

Value	Count	Frequency (%)
0.011	1	< 0.1%
0.019	3	< 0.1%
0.022	2	< 0.1%
0.026	4	< 0.1%
0.03	10	< 0.1%
0.033	18	< 0.1%
0.037	20	< 0.1%
0.041	34	0.1%
0.044	53	0.1%
0.048	74	0.1%

Value	Count	Frequency (%)
936	1	< 0.1%
933	1	< 0.1%
922	2	< 0.1%
909	1	< 0.1%
903	1	< 0.1%
897	1	< 0.1%
863	1	< 0.1%
856	1	< 0.1%
855	1	< 0.1%
851	1	< 0.1%

PowerConsumption_Zone1
Real number (ℝ)

High correlation

Distinct	27709
Distinct (%)	52.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32344.971

Minimum	13895.696
Maximum	52204.395
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	13895.696
5-th percentile	21867.342
Q1	26310.669
median	32265.92
Q3	37309.018
95-th percentile	44712.058
Maximum	52204.395
Range	38308.699
Interquartile range (IQR)	10998.349

Descriptive statistics

Standard deviation	7130.5626
Coefficient of variation (CV)	0.22045352
Kurtosis	-0.75405439
Mean	32344.971
Median Absolute Deviation (MAD)	5513.8039
Skewness	0.22886369
Sum	1.695394 × 10⁹
Variance	50844922
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
34560	30	0.1%
23040	24	< 0.1%
28800	19	< 0.1%
25920	18	< 0.1%
23672.42196	13	< 0.1%
35441.31148	13	< 0.1%
21063.34426	12	< 0.1%
21950.76923	12	< 0.1%
31680	12	< 0.1%
22880.68085	11	< 0.1%
Other values (27699)	52252	99.7%

Value	Count	Frequency (%)
13895.6962	1	< 0.1%
13920	1	< 0.1%
13932.1519	1	< 0.1%
14090.12658	1	< 0.1%
14327.08861	1	< 0.1%
14557.97468	1	< 0.1%
14612.65823	1	< 0.1%
15013.67089	1	< 0.1%
15524.05063	1	< 0.1%
15572.65823	1	< 0.1%

Value	Count	Frequency (%)
52204.39512	1	< 0.1%
52146.85905	1	< 0.1%
52038.1798	1	< 0.1%
51955.07214	1	< 0.1%
51916.71476	1	< 0.1%
51820.82131	1	< 0.1%
51776.07103	1	< 0.1%
51737.71365	1	< 0.1%
51731.32075	1	< 0.1%
51718.53496	1	< 0.1%

PowerConsumption_Zone2
Real number (ℝ)

High correlation

Distinct	29621
Distinct (%)	56.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	21042.509

Minimum	8560.0815
Maximum	37408.861
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	8560.0815
5-th percentile	13284.146
Q1	16980.766
median	20823.168
Q3	24713.718
95-th percentile	30387.137
Maximum	37408.861
Range	28848.779
Interquartile range (IQR)	7732.9515

Descriptive statistics

Standard deviation	5201.4659
Coefficient of variation (CV)	0.24718848
Kurtosis	-0.43739724
Mean	21042.509
Median Absolute Deviation (MAD)	3867.0469
Skewness	0.32887602
Sum	1.1029642 × 10⁹
Variance	27055247
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
21600	16	< 0.1%
25200	12	< 0.1%
14148.32827	11	< 0.1%
23400	11	< 0.1%
22800	11	< 0.1%
16158.83576	11	< 0.1%
13732.5228	10	< 0.1%
18000	10	< 0.1%
13539.20973	10	< 0.1%
22962.16216	10	< 0.1%
Other values (29611)	52304	99.8%

Value	Count	Frequency (%)
8560.081466	1	< 0.1%
8585.743381	1	< 0.1%
8633.401222	1	< 0.1%
8651.731161	1	< 0.1%
8787.372709	1	< 0.1%
8897.352342	1	< 0.1%
8912.016293	1	< 0.1%
9131.97556	1	< 0.1%
9307.942974	1	< 0.1%
9365.944272	1	< 0.1%

Value	Count	Frequency (%)
37408.86076	1	< 0.1%
36645.56962	1	< 0.1%
36482.78775	1	< 0.1%
36437.17001	1	< 0.1%
36429.56705	1	< 0.1%
36391.55227	1	< 0.1%
36353.53749	1	< 0.1%
36201.47835	1	< 0.1%
36129.25026	1	< 0.1%
36110.24287	1	< 0.1%

PowerConsumption_Zone3
Real number (ℝ)

High correlation

Distinct	22838
Distinct (%)	43.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17835.406

Minimum	5935.1741
Maximum	47598.326
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	819.0 KiB

Quantile statistics

Minimum	5935.1741
5-th percentile	9519.3277
Q1	13129.327
median	16415.117
Q3	21624.1
95-th percentile	29905.709
Maximum	47598.326
Range	41663.152
Interquartile range (IQR)	8494.7738

Descriptive statistics

Standard deviation	6622.1651
Coefficient of variation (CV)	0.3712932
Kurtosis	1.0863933
Mean	17835.406
Median Absolute Deviation (MAD)	3866.1593
Skewness	1.0238715
Sum	9.3486065 × 10⁸
Variance	43853071
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17280	26	< 0.1%
11520	19	< 0.1%
9600	17	< 0.1%
9450.180072	17	< 0.1%
9588.47539	16	< 0.1%
9173.589436	15	< 0.1%
9795.918367	15	< 0.1%
16366.26506	15	< 0.1%
9617.286915	15	< 0.1%
9329.171669	14	< 0.1%
Other values (22828)	52247	99.7%

Value	Count	Frequency (%)
5935.17407	1	< 0.1%
6044.657863	1	< 0.1%
6061.944778	1	< 0.1%
6108.043217	1	< 0.1%
6119.567827	1	< 0.1%
6182.953181	1	< 0.1%
6200.240096	1	< 0.1%
6211.764706	1	< 0.1%
6223.289316	1	< 0.1%
6252.10084	1	< 0.1%

Value	Count	Frequency (%)
47598.32636	2	< 0.1%
47580.25105	1	< 0.1%
47507.94979	1	< 0.1%
47441.67364	1	< 0.1%
47435.64854	1	< 0.1%
47429.62343	1	< 0.1%
47405.52301	1	< 0.1%
47291.04603	1	< 0.1%
47278.99582	1	< 0.1%
47266.94561	1	< 0.1%

Year
Categorical

Constant

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.4 MiB

2017	52416

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	209664
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017
2nd row	2017
3rd row	2017
4th row	2017
5th row	2017

Common Values

Value	Count	Frequency (%)
2017	52416	100.0%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
2017	52416	100.0%

Most occurring characters

Value	Count	Frequency (%)
2	52416	25.0%
0	52416	25.0%
1	52416	25.0%
7	52416	25.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	209664	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	52416	25.0%
0	52416	25.0%
1	52416	25.0%
7	52416	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	209664	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	52416	25.0%
0	52416	25.0%
1	52416	25.0%
7	52416	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	209664	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	52416	25.0%
0	52416	25.0%
1	52416	25.0%
7	52416	25.0%

Month
Real number (ℝ)

Distinct	12
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.510989

Minimum	1
Maximum	12
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	614.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	4
median	7
Q3	9.25
95-th percentile	12
Maximum	12
Range	11
Interquartile range (IQR)	5.25

Descriptive statistics

Standard deviation	3.440642
Coefficient of variation (CV)	0.52843615
Kurtosis	-1.2048069
Mean	6.510989
Median Absolute Deviation (MAD)	3
Skewness	-0.0085027926
Sum	341280
Variance	11.838017
Monotonicity	Increasing

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
1	4464	8.5%
3	4464	8.5%
5	4464	8.5%
7	4464	8.5%
8	4464	8.5%
10	4464	8.5%
4	4320	8.2%
6	4320	8.2%
9	4320	8.2%
11	4320	8.2%
Other values (2)	8352	15.9%

Value	Count	Frequency (%)
1	4464	8.5%
2	4032	7.7%
3	4464	8.5%
4	4320	8.2%
5	4464	8.5%
6	4320	8.2%
7	4464	8.5%
8	4464	8.5%
9	4320	8.2%
10	4464	8.5%

Value	Count	Frequency (%)
12	4320	8.2%
11	4320	8.2%
10	4464	8.5%
9	4320	8.2%
8	4464	8.5%
7	4464	8.5%
6	4320	8.2%
5	4464	8.5%
4	4320	8.2%
3	4464	8.5%

Day
Real number (ℝ)

Distinct	31
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15.678571

Minimum	1
Maximum	31
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	614.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	8
median	16
Q3	23
95-th percentile	29
Maximum	31
Range	30
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	8.7718216
Coefficient of variation (CV)	0.55947837
Kurtosis	-1.193143
Mean	15.678571
Median Absolute Deviation (MAD)	8
Skewness	0.0074418652
Sum	821808
Variance	76.944855
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=31)

Value	Count	Frequency (%)
1	1728	3.3%
2	1728	3.3%
28	1728	3.3%
27	1728	3.3%
26	1728	3.3%
25	1728	3.3%
24	1728	3.3%
23	1728	3.3%
22	1728	3.3%
21	1728	3.3%
Other values (21)	35136	67.0%

Value	Count	Frequency (%)
1	1728	3.3%
2	1728	3.3%
3	1728	3.3%
4	1728	3.3%
5	1728	3.3%
6	1728	3.3%
7	1728	3.3%
8	1728	3.3%
9	1728	3.3%
10	1728	3.3%

Value	Count	Frequency (%)
31	864	1.6%
30	1584	3.0%
29	1584	3.0%
28	1728	3.3%
27	1728	3.3%
26	1728	3.3%
25	1728	3.3%
24	1728	3.3%
23	1728	3.3%
22	1728	3.3%

Hour
Real number (ℝ)

High correlation Zeros

Distinct	24
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11.5

Minimum	0
Maximum	23
Zeros	2184
Zeros (%)	4.2%
Negative	0
Negative (%)	0.0%
Memory size	614.2 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	5.75
median	11.5
Q3	17.25
95-th percentile	22
Maximum	23
Range	23
Interquartile range (IQR)	11.5

Descriptive statistics

Standard deviation	6.9222526
Coefficient of variation (CV)	0.60193501
Kurtosis	-1.2041743
Mean	11.5
Median Absolute Deviation (MAD)	6
Skewness	0
Sum	602784
Variance	47.917581
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	2184	4.2%
1	2184	4.2%
22	2184	4.2%
21	2184	4.2%
20	2184	4.2%
19	2184	4.2%
18	2184	4.2%
17	2184	4.2%
16	2184	4.2%
15	2184	4.2%
Other values (14)	30576	58.3%

Value	Count	Frequency (%)
0	2184	4.2%
1	2184	4.2%
2	2184	4.2%
3	2184	4.2%
4	2184	4.2%
5	2184	4.2%
6	2184	4.2%
7	2184	4.2%
8	2184	4.2%
9	2184	4.2%

Value	Count	Frequency (%)
23	2184	4.2%
22	2184	4.2%
21	2184	4.2%
20	2184	4.2%
19	2184	4.2%
18	2184	4.2%
17	2184	4.2%
16	2184	4.2%
15	2184	4.2%
14	2184	4.2%

Minute
Real number (ℝ)

Zeros

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	25

Minimum	0
Maximum	50
Zeros	8736
Zeros (%)	16.7%
Negative	0
Negative (%)	0.0%
Memory size	614.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	10
median	25
Q3	40
95-th percentile	50
Maximum	50
Range	50
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	17.078414
Coefficient of variation (CV)	0.68313657
Kurtosis	-1.268578
Mean	25
Median Absolute Deviation (MAD)	15
Skewness	0
Sum	1310400
Variance	291.67223
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	8736	16.7%
10	8736	16.7%
20	8736	16.7%
30	8736	16.7%
40	8736	16.7%
50	8736	16.7%

Value	Count	Frequency (%)
0	8736	16.7%
10	8736	16.7%
20	8736	16.7%
30	8736	16.7%
40	8736	16.7%
50	8736	16.7%

Value	Count	Frequency (%)
50	8736	16.7%
40	8736	16.7%
30	8736	16.7%
20	8736	16.7%
10	8736	16.7%
0	8736	16.7%

	Day	DiffuseFlows	GeneralDiffuseFlows	Hour	Humidity	Minute	Month	PowerConsumption_Zone1	PowerConsumption_Zone2	PowerConsumption_Zone3	Temperature	WindSpeed
Day	1.000	-0.016	0.006	0.000	-0.047	0.000	0.004	0.026	0.052	-0.020	0.013	0.175
DiffuseFlows	-0.016	1.000	0.786	0.142	-0.253	-0.001	-0.099	0.125	0.097	-0.021	0.261	0.022
GeneralDiffuseFlows	0.006	0.786	1.000	0.195	-0.459	0.000	0.019	0.261	0.242	0.085	0.472	0.157
Hour	0.000	0.142	0.195	1.000	-0.253	0.000	0.000	0.732	0.679	0.467	0.184	0.006
Humidity	-0.047	-0.253	-0.459	-0.253	1.000	0.001	-0.011	-0.300	-0.309	-0.212	-0.378	-0.181
Minute	0.000	-0.001	0.000	0.000	0.001	1.000	0.000	0.000	-0.000	-0.000	-0.000	0.007
Month	0.004	-0.099	0.019	0.000	-0.011	0.000	1.000	-0.009	0.300	-0.322	0.304	0.146
PowerConsumption_Zone1	0.026	0.125	0.261	0.732	-0.300	0.000	-0.009	1.000	0.851	0.748	0.433	0.107
PowerConsumption_Zone2	0.052	0.097	0.242	0.679	-0.309	-0.000	0.300	0.851	1.000	0.538	0.379	0.087
PowerConsumption_Zone3	-0.020	-0.021	0.085	0.467	-0.212	-0.000	-0.322	0.748	0.538	1.000	0.436	0.079
Temperature	0.013	0.261	0.472	0.184	-0.378	-0.000	0.304	0.433	0.379	0.436	1.000	0.326
WindSpeed	0.175	0.022	0.157	0.006	-0.181	0.007	0.146	0.107	0.087	0.079	0.326	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

	Temperature	Humidity	WindSpeed	GeneralDiffuseFlows	DiffuseFlows	PowerConsumption_Zone1	PowerConsumption_Zone2	PowerConsumption_Zone3	Year	Month	Day	Hour	Minute
Datetime
2017-01-01 00:00:00	6.559	73.8	0.083	0.051	0.119	34055.69620	16128.87538	20240.96386	2017	1	1	0	0
2017-01-01 00:10:00	6.414	74.5	0.083	0.070	0.085	29814.68354	19375.07599	20131.08434	2017	1	1	0	10
2017-01-01 00:20:00	6.313	74.5	0.080	0.062	0.100	29128.10127	19006.68693	19668.43373	2017	1	1	0	20
2017-01-01 00:30:00	6.121	75.0	0.083	0.091	0.096	28228.86076	18361.09422	18899.27711	2017	1	1	0	30
2017-01-01 00:40:00	5.921	75.7	0.081	0.048	0.085	27335.69620	17872.34043	18442.40964	2017	1	1	0	40
2017-01-01 00:50:00	5.853	76.9	0.081	0.059	0.108	26624.81013	17416.41337	18130.12048	2017	1	1	0	50
2017-01-01 01:00:00	5.641	77.7	0.080	0.048	0.096	25998.98734	16993.31307	17945.06024	2017	1	1	1	0
2017-01-01 01:10:00	5.496	78.2	0.085	0.055	0.093	25446.07595	16661.39818	17459.27711	2017	1	1	1	10
2017-01-01 01:20:00	5.678	78.1	0.081	0.066	0.141	24777.72152	16227.35562	17025.54217	2017	1	1	1	20
2017-01-01 01:30:00	5.491	77.3	0.082	0.062	0.111	24279.49367	15939.20973	16794.21687	2017	1	1	1	30

	Temperature	Humidity	WindSpeed	GeneralDiffuseFlows	DiffuseFlows	PowerConsumption_Zone1	PowerConsumption_Zone2	PowerConsumption_Zone3	Year	Month	Day	Hour	Minute
Datetime
2017-12-30 22:20:00	7.650	70.1	0.081	0.062	0.122	34323.95437	28676.28107	15684.99400	2017	12	30	22	20
2017-12-30 22:30:00	7.480	71.0	0.085	0.062	0.104	33776.42586	28230.74563	15546.69868	2017	12	30	22	30
2017-12-30 22:40:00	7.390	71.2	0.079	0.066	0.100	33387.07224	27814.66708	15396.87875	2017	12	30	22	40
2017-12-30 22:50:00	7.340	71.0	0.084	0.037	0.119	32815.20913	27564.28352	15172.14886	2017	12	30	22	50
2017-12-30 23:00:00	7.070	72.5	0.080	0.059	0.093	32158.17490	27273.39675	14987.75510	2017	12	30	23	0
2017-12-30 23:10:00	7.010	72.4	0.080	0.040	0.096	31160.45627	26857.31820	14780.31212	2017	12	30	23	10
2017-12-30 23:20:00	6.947	72.6	0.082	0.051	0.093	30430.41825	26124.57809	14428.81152	2017	12	30	23	20
2017-12-30 23:30:00	6.900	72.8	0.086	0.084	0.074	29590.87452	25277.69254	13806.48259	2017	12	30	23	30
2017-12-30 23:40:00	6.758	73.0	0.080	0.066	0.089	28958.17490	24692.23688	13512.60504	2017	12	30	23	40
2017-12-30 23:50:00	6.580	74.1	0.081	0.062	0.111	28349.80989	24055.23167	13345.49820	2017	12	30	23	50

Overview

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample